YData Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	10
Number of observations	53794
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.5 MiB
Average record size in memory	88.0 B

Variable types

Numeric	9
Categorical	1

Alerts

`carat` is highly overall correlated with `price` and 3 other fields	High correlation
`price` is highly overall correlated with `carat` and 3 other fields	High correlation
`x` is highly overall correlated with `carat` and 3 other fields	High correlation
`y` is highly overall correlated with `carat` and 3 other fields	High correlation
`z` is highly overall correlated with `carat` and 3 other fields	High correlation
`color` has 6755 (12.6%) zeros	Zeros
`clarity` has 740 (1.4%) zeros	Zeros

Reproduction

Analysis started	2025-12-25 14:19:23.507089
Analysis finished	2025-12-25 14:19:32.716315
Duration	9.21 seconds
Software version	ydata-profiling v4.16.1
Download configuration	config.json

carat
Real number (ℝ)

High correlation

Distinct	273
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.79778005

Minimum	0.2
Maximum	5.01
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	840.5 KiB

Quantile statistics

Minimum	0.2
5-th percentile	0.3
Q1	0.4
median	0.7
Q3	1.04
95-th percentile	1.7
Maximum	5.01
Range	4.81
Interquartile range (IQR)	0.64

Descriptive statistics

Standard deviation	0.47339024
Coefficient of variation (CV)	0.5933844
Kurtosis	1.2471577
Mean	0.79778005
Median Absolute Deviation (MAD)	0.32
Skewness	1.1136511
Sum	42915.78
Variance	0.22409832
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3	2596	4.8%
1.01	2240	4.2%
0.31	2238	4.2%
0.7	1981	3.7%
0.32	1827	3.4%
1	1548	2.9%
0.9	1484	2.8%
0.41	1378	2.6%
0.71	1292	2.4%
0.4	1291	2.4%
Other values (263)	35919	66.8%

Value	Count	Frequency (%)
0.2	12	< 0.1%
0.21	9	< 0.1%
0.22	5	< 0.1%
0.23	293	0.5%
0.24	254	0.5%
0.25	212	0.4%
0.26	253	0.5%
0.27	233	0.4%
0.28	198	0.4%
0.29	130	0.2%

Value	Count	Frequency (%)
5.01	1	< 0.1%
4.5	1	< 0.1%
4.13	1	< 0.1%
4.01	2	< 0.1%
4	1	< 0.1%
3.67	1	< 0.1%
3.65	1	< 0.1%
3.51	1	< 0.1%
3.5	1	< 0.1%
3.4	1	< 0.1%

cut
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	840.5 KiB

2	21488
3	13748
4	12069
1	4891
0	1598

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	53794
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	3
3rd row	1
4th row	3
5th row	1

Common Values

Value	Count	Frequency (%)
2	21488	39.9%
3	13748	25.6%
4	12069	22.4%
1	4891	9.1%
0	1598	3.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	21488	39.9%
3	13748	25.6%
4	12069	22.4%
1	4891	9.1%
0	1598	3.0%

Most occurring characters

Value	Count	Frequency (%)
2	21488	39.9%
3	13748	25.6%
4	12069	22.4%
1	4891	9.1%
0	1598	3.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	53794	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	21488	39.9%
3	13748	25.6%
4	12069	22.4%
1	4891	9.1%
0	1598	3.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	53794	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	21488	39.9%
3	13748	25.6%
4	12069	22.4%
1	4891	9.1%
0	1598	3.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	53794	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	21488	39.9%
3	13748	25.6%
4	12069	22.4%
1	4891	9.1%
0	1598	3.0%

color
Real number (ℝ)

Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5939138

Minimum	0
Maximum	6
Zeros	6755
Zeros (%)	12.6%
Negative	0
Negative (%)	0.0%
Memory size	840.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.7011165
Coefficient of variation (CV)	0.65581074
Kurtosis	-0.86640993
Mean	2.5939138
Median Absolute Deviation (MAD)	1
Skewness	0.19000596
Sum	139537
Variance	2.8937975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	11262	20.9%
1	9776	18.2%
2	9520	17.7%
4	8272	15.4%
0	6755	12.6%
5	5407	10.1%
6	2802	5.2%

Value	Count	Frequency (%)
0	6755	12.6%
1	9776	18.2%
2	9520	17.7%
3	11262	20.9%
4	8272	15.4%
5	5407	10.1%
6	2802	5.2%

Value	Count	Frequency (%)
6	2802	5.2%
5	5407	10.1%
4	8272	15.4%
3	11262	20.9%
2	9520	17.7%
1	9776	18.2%
0	6755	12.6%

clarity
Real number (ℝ)

Zeros

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.8357624

Minimum	0
Maximum	7
Zeros	740
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	840.5 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	4
Q3	5
95-th percentile	7
Maximum	7
Range	7
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.7248716
Coefficient of variation (CV)	0.44968155
Kurtosis	-0.82131591
Mean	3.8357624
Median Absolute Deviation (MAD)	1
Skewness	0.17416379
Sum	206341
Variance	2.9751819
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	13032	24.2%
5	12229	22.7%
3	9150	17.0%
4	8156	15.2%
7	5056	9.4%
6	3647	6.8%
1	1784	3.3%
0	740	1.4%

Value	Count	Frequency (%)
0	740	1.4%
1	1784	3.3%
2	13032	24.2%
3	9150	17.0%
4	8156	15.2%
5	12229	22.7%
6	3647	6.8%
7	5056	9.4%

Value	Count	Frequency (%)
7	5056	9.4%
6	3647	6.8%
5	12229	22.7%
4	8156	15.2%
3	9150	17.0%
2	13032	24.2%
1	1784	3.3%
0	740	1.4%

depth
Real number (ℝ)

Distinct	184
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.74808

Minimum	43
Maximum	79
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	840.5 KiB

Quantile statistics

Minimum	43
5-th percentile	59.3
Q1	61
median	61.8
Q3	62.5
95-th percentile	63.8
Maximum	79
Range	36
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	1.4299091
Coefficient of variation (CV)	0.023157143
Kurtosis	5.4129891
Mean	61.74808
Median Absolute Deviation (MAD)	0.7
Skewness	-0.11425026
Sum	3321676.2
Variance	2.0446401
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	2233	4.2%
61.9	2160	4.0%
61.8	2069	3.8%
62.2	2033	3.8%
62.1	2011	3.7%
61.6	1950	3.6%
62.3	1931	3.6%
61.7	1899	3.5%
62.4	1787	3.3%
61.5	1717	3.2%
Other values (174)	34004	63.2%

Value	Count	Frequency (%)
43	2	< 0.1%
44	1	< 0.1%
50.8	1	< 0.1%
51	1	< 0.1%
52.2	1	< 0.1%
52.3	1	< 0.1%
52.7	1	< 0.1%
53	1	< 0.1%
53.1	1	< 0.1%
53.2	2	< 0.1%

Value	Count	Frequency (%)
79	1	< 0.1%
78.2	1	< 0.1%
73.6	1	< 0.1%
72.9	1	< 0.1%
72.2	1	< 0.1%
71.8	1	< 0.1%
71.6	2	< 0.1%
71.3	1	< 0.1%
71.2	1	< 0.1%
71	1	< 0.1%

table
Real number (ℝ)

Distinct	127
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57.458109

Minimum	43
Maximum	95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	840.5 KiB

Quantile statistics

Minimum	43
5-th percentile	54
Q1	56
median	57
Q3	59
95-th percentile	61
Maximum	95
Range	52
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2336791
Coefficient of variation (CV)	0.038874915
Kurtosis	2.7753598
Mean	57.458109
Median Absolute Deviation (MAD)	1
Skewness	0.79222729
Sum	3090901.5
Variance	4.9893222
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56	9851	18.3%
57	9695	18.0%
58	8352	15.5%
59	6562	12.2%
55	6242	11.6%
60	4232	7.9%
54	2583	4.8%
61	2277	4.2%
62	1267	2.4%
63	587	1.1%
Other values (117)	2146	4.0%

Value	Count	Frequency (%)
43	1	< 0.1%
44	1	< 0.1%
49	2	< 0.1%
50	2	< 0.1%
50.1	1	< 0.1%
51	9	< 0.1%
51.6	1	< 0.1%
52	56	0.1%
52.4	1	< 0.1%
52.8	2	< 0.1%

Value	Count	Frequency (%)
95	1	< 0.1%
79	1	< 0.1%
76	1	< 0.1%
73	3	< 0.1%
71	1	< 0.1%
70	9	< 0.1%
69	9	< 0.1%
68	21	< 0.1%
67	42	0.1%
66	91	0.2%

price
Real number (ℝ)

High correlation

Distinct	11602
Distinct (%)	21.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3933.0651

Minimum	326
Maximum	18823
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	840.5 KiB

Quantile statistics

Minimum	326
5-th percentile	544
Q1	951
median	2401
Q3	5326.75
95-th percentile	13100.05
Maximum	18823
Range	18497
Interquartile range (IQR)	4375.75

Descriptive statistics

Standard deviation	3988.1145
Coefficient of variation (CV)	1.0139966
Kurtosis	2.1784531
Mean	3933.0651
Median Absolute Deviation (MAD)	1670
Skewness	1.6182399
Sum	2.115753 × 10⁸
Variance	15905057
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
605	132	0.2%
802	126	0.2%
625	125	0.2%
776	124	0.2%
828	124	0.2%
698	121	0.2%
544	120	0.2%
789	120	0.2%
552	113	0.2%
666	112	0.2%
Other values (11592)	52577	97.7%

Value	Count	Frequency (%)
326	2	< 0.1%
327	1	< 0.1%
334	1	< 0.1%
335	1	< 0.1%
336	2	< 0.1%
337	2	< 0.1%
338	1	< 0.1%
339	1	< 0.1%
340	1	< 0.1%
342	1	< 0.1%

Value	Count	Frequency (%)
18823	1	< 0.1%
18818	1	< 0.1%
18806	1	< 0.1%
18804	1	< 0.1%
18803	1	< 0.1%
18797	1	< 0.1%
18795	2	< 0.1%
18791	2	< 0.1%
18788	1	< 0.1%
18787	1	< 0.1%

x
Real number (ℝ)

High correlation

Distinct	554
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7312144

Minimum	0
Maximum	10.74
Zeros	7
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	840.5 KiB

Quantile statistics

Minimum	0
5-th percentile	4.29
Q1	4.71
median	5.7
Q3	6.54
95-th percentile	7.66
Maximum	10.74
Range	10.74
Interquartile range (IQR)	1.83

Descriptive statistics

Standard deviation	1.1206947
Coefficient of variation (CV)	0.19554228
Kurtosis	-0.62906812
Mean	5.7312144
Median Absolute Deviation (MAD)	0.92
Skewness	0.37962391
Sum	308304.95
Variance	1.2559567
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.37	444	0.8%
4.34	436	0.8%
4.33	428	0.8%
4.38	426	0.8%
4.32	422	0.8%
4.35	406	0.8%
4.39	387	0.7%
4.31	384	0.7%
4.36	384	0.7%
4.4	368	0.7%
Other values (544)	49709	92.4%

Value	Count	Frequency (%)
0	7	< 0.1%
3.73	2	< 0.1%
3.74	1	< 0.1%
3.76	1	< 0.1%
3.77	1	< 0.1%
3.79	2	< 0.1%
3.81	3	< 0.1%
3.82	2	< 0.1%
3.83	3	< 0.1%
3.84	4	< 0.1%

Value	Count	Frequency (%)
10.74	1	< 0.1%
10.23	1	< 0.1%
10.14	1	< 0.1%
10.02	1	< 0.1%
10.01	1	< 0.1%
10	1	< 0.1%
9.86	1	< 0.1%
9.66	1	< 0.1%
9.65	1	< 0.1%
9.54	1	< 0.1%

y
Real number (ℝ)

High correlation

Distinct	552
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7346533

Minimum	0
Maximum	58.9
Zeros	6
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	840.5 KiB

Quantile statistics

Minimum	0
5-th percentile	4.3
Q1	4.72
median	5.71
Q3	6.54
95-th percentile	7.64
Maximum	58.9
Range	58.9
Interquartile range (IQR)	1.82

Descriptive statistics

Standard deviation	1.1412092
Coefficient of variation (CV)	0.1990023
Kurtosis	91.752305
Mean	5.7346533
Median Absolute Deviation (MAD)	0.92
Skewness	2.445768
Sum	308489.94
Variance	1.3023584
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.34	436	0.8%
4.37	432	0.8%
4.35	424	0.8%
4.33	420	0.8%
4.32	411	0.8%
4.39	406	0.8%
4.38	404	0.8%
4.31	384	0.7%
4.41	383	0.7%
4.4	381	0.7%
Other values (542)	49713	92.4%

Value	Count	Frequency (%)
0	6	< 0.1%
3.68	1	< 0.1%
3.71	2	< 0.1%
3.72	1	< 0.1%
3.73	1	< 0.1%
3.75	1	< 0.1%
3.77	2	< 0.1%
3.78	5	< 0.1%
3.8	1	< 0.1%
3.81	1	< 0.1%

Value	Count	Frequency (%)
58.9	1	< 0.1%
31.8	1	< 0.1%
10.54	1	< 0.1%
10.16	1	< 0.1%
10.1	1	< 0.1%
9.94	2	< 0.1%
9.85	1	< 0.1%
9.81	1	< 0.1%
9.63	1	< 0.1%
9.59	1	< 0.1%

z
Real number (ℝ)

High correlation

Distinct	375
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.5387136

Minimum	0
Maximum	31.8
Zeros	19
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	840.5 KiB

Quantile statistics

Minimum	0
5-th percentile	2.65
Q1	2.91
median	3.53
Q3	4.03
95-th percentile	4.73
Maximum	31.8
Range	31.8
Interquartile range (IQR)	1.12

Descriptive statistics

Standard deviation	0.70503748
Coefficient of variation (CV)	0.19923553
Kurtosis	47.383974
Mean	3.5387136
Median Absolute Deviation (MAD)	0.57
Skewness	1.5290234
Sum	190361.56
Variance	0.49707785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.7	761	1.4%
2.69	745	1.4%
2.71	733	1.4%
2.68	730	1.4%
2.72	691	1.3%
2.67	647	1.2%
2.73	605	1.1%
2.66	553	1.0%
2.74	545	1.0%
4.02	538	1.0%
Other values (365)	47246	87.8%

Value	Count	Frequency (%)
0	19	< 0.1%
1.07	1	< 0.1%
1.41	1	< 0.1%
1.53	1	< 0.1%
2.06	1	< 0.1%
2.24	1	< 0.1%
2.25	1	< 0.1%
2.26	1	< 0.1%
2.27	1	< 0.1%
2.28	1	< 0.1%

Value	Count	Frequency (%)
31.8	1	< 0.1%
8.06	1	< 0.1%
6.98	1	< 0.1%
6.72	1	< 0.1%
6.43	1	< 0.1%
6.38	1	< 0.1%
6.31	1	< 0.1%
6.27	1	< 0.1%
6.24	1	< 0.1%
6.17	1	< 0.1%

	carat	clarity	color	cut	depth	price	table	x	y	z
carat	1.000	-0.216	0.249	0.115	0.030	0.963	0.194	0.996	0.996	0.993
clarity	-0.216	1.000	-0.023	0.142	-0.052	-0.116	-0.085	-0.214	-0.212	-0.217
color	0.249	-0.023	1.000	0.036	0.049	0.150	0.028	0.245	0.245	0.251
cut	0.115	0.142	0.036	1.000	0.405	0.093	0.290	0.148	0.107	0.096
depth	0.030	-0.052	0.049	0.405	1.000	0.010	-0.245	-0.023	-0.025	0.104
price	0.963	-0.116	0.150	0.093	0.010	1.000	0.171	0.963	0.963	0.957
table	0.194	-0.085	0.028	0.290	-0.245	0.171	1.000	0.201	0.195	0.159
x	0.996	-0.214	0.245	0.148	-0.023	0.963	0.201	1.000	0.998	0.987
y	0.996	-0.212	0.245	0.107	-0.025	0.963	0.195	0.998	1.000	0.987
z	0.993	-0.217	0.251	0.096	0.104	0.957	0.159	0.987	0.987	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	carat	cut	color	clarity	depth	table	price	x	y	z
0	0.23	2	1	3	61.5	55.0	326	3.95	3.98	2.43
1	0.21	3	1	2	59.8	61.0	326	3.89	3.84	2.31
2	0.23	1	1	4	56.9	65.0	327	4.05	4.07	2.31
3	0.29	3	5	5	62.4	58.0	334	4.20	4.23	2.63
4	0.31	1	6	3	63.3	58.0	335	4.34	4.35	2.75
5	0.24	4	6	7	62.8	57.0	336	3.94	3.96	2.48
6	0.24	4	5	6	62.3	57.0	336	3.95	3.98	2.47
7	0.26	4	4	2	61.9	55.0	337	4.07	4.11	2.53
8	0.22	0	1	5	65.1	61.0	337	3.87	3.78	2.49
9	0.23	4	4	4	59.4	61.0	338	4.00	4.05	2.39

	carat	cut	color	clarity	depth	table	price	x	y	z
53930	0.71	3	1	2	60.5	55.0	2756	5.79	5.74	3.49
53931	0.71	3	2	2	59.8	62.0	2756	5.74	5.73	3.43
53932	0.70	4	1	5	60.5	59.0	2757	5.71	5.76	3.47
53933	0.70	4	1	5	61.2	59.0	2757	5.69	5.72	3.49
53934	0.72	3	0	2	62.7	59.0	2757	5.69	5.73	3.58
53935	0.72	2	0	2	60.8	57.0	2757	5.75	5.76	3.50
53936	0.72	1	0	2	63.1	55.0	2757	5.69	5.75	3.61
53937	0.70	4	0	2	62.8	60.0	2757	5.66	5.68	3.56
53938	0.86	3	4	3	61.0	58.0	2757	6.15	6.12	3.74
53939	0.75	2	0	3	62.2	55.0	2757	5.83	5.87	3.64

Overview

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample